/**
 * FileName: EmployeeDao.java
 * 员工角色Dao接口层
 *
 * @author  王威
 * @Date    2021/11/29
 * @version 1.00
 **/
package com.site.dao;
import com.site.pojo.EmployeeRole;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface EmployeeRoleDao {
    /*查询所有员工的角色*/
    List<EmployeeRole> selectAll() throws SQLException;

    /*根据员工id查询员工角色*/
    EmployeeRole selectById(EmployeeRole emp) throws SQLException;

    /*添加员工的角色*/
    int addEmployeeRole(Connection con, EmployeeRole employeeRole) throws SQLException;

    /*删除员工的角色*/
    int delEmployeeRole(Connection con, EmployeeRole employeeRole);

    /*修改员工的角色*/
    int updateEmployeeRole(Connection con, EmployeeRole employeeRole);
}
